package com.bolingcavalry.crm.customer.mapper;/*
 * @Auther:Sadie
 * @Date:2025/4/24
 * @Description:
 * @VERSON:1.8
 */

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.entity.customer.CustomerCompanies;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface CustomerCompaniesMapper extends BaseMapper<CustomerCompanies> {
    @Select("SELECT id FROM customer_companies WHERE company_name LIKE CONCAT('%', #{customerCompanyName}, '%')")
    List<Long> selectCompanyIdsByName(String customerCompanyName);

    int isExistInAfterSales(List<Long> ids);

    int isExistInServiceProblem(List<Long> ids);
}
